Urgent help- Need to check unique items from table1 and get dimension data from table 2 for those items

Database
N/A

Urgent help- Need to check unique items from table1 and get dimension data from table 2 for those items

Hi,

I have a requirement:

Table A - contains Item information

Table B - contains physical dimension data for those items

Both are final tables

Both table have one column in common(idn)

I need to 

take Unique Items from Final table A  check in table B for how many we are getting the physical dimension data.

1 REPLY
Enthusiast

Re: Urgent help- Need to check unique items from table1 and get dimension data from table 2 for those items

I am going to assume that you want to get the corresponding information present in both the tables, you need to do an inner join

select columns from tablea A, tableb B where A.commoncolumn = B.commoncolumn ;