Ask - How to Find Data From Multiple Table

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Ask

Ask questions, discuss or help others by answering


	Ask a question


	Subscribe..

How to Find Data From Multiple Table

Dec 1 2011 12:00AM by MayankPatel

I have Three Table Like

News column ==> id ,Newsname Events column ==> id ,Eventname Article column ==> id ,Articlename

when i entered String
how to find data from all three table which is match string? Thanks Mayank

Submitted under: Microsoft SQL Server · TSQL · · ·

Previous: CTEs, Table Joins and XML Auto
Next: Macro substitution in TSQL

MayankPatel

958 · 0% · 27

1 Replies

Try this code


DECLARE @para AS VARCHAR(50)
SET @para = 'Search String'

SELECT  'New Column' AS TableName ,
        id ,
        Newsname
FROM    [New Column]
WHERE   Newsname LIKE '%' + @para + '%'
UNION ALL
SELECT  'Events Column' AS TableName ,
        id ,
        Eventname
FROM    [Events Column]
WHERE   Eventname LIKE '%' + @para + '%'
UNION ALL
SELECT  'Article Column' AS TableName ,
        id ,
        Articlename
FROM    [Article Column]
WHERE   Articlename LIKE '%' + @para + '%'

commented on Dec 2 2011 3:03AM

Mitesh Modi

18 · 10% · 3078

Your Reply

Sign Up or Login to post a comment.