Common Data

[viralbhatt]

hello,

I have 2 tables called Table1 ( has field called Mydata) and table2 (has Field called YourData).

Mydata has followind data 1, 2, 3 and
yourData has 2,3,4

2 and 3 are comman data. how can I write query or type of function I can use to bring comman data

I have used Union table that brings all record.

Thank you
Viral

 

[neileg]

Well, if you create an inner join between the two tables on the fields you specify, it will return the records with common data. However if the values are repeated in either table you will get multiple matches.

 

[viralbhatt]

Thank you

It's working now, thank you for your reply

Viral