How to find the specific badge id by using the inner join

[gingank]

Hi guys i got a problem with this i can get data from the table by using sql :-Select * from staff_badgeTracking inner join staff_badgeTrackingNew
On staff_badgeTracking.Badge_ID = staff_badgeTrackingNew.Badge_ID

The point is if i wan to find a specific badge id like 1234 then it will get the data from two table so how to write the code ?

I write like this but it show error

Select * from staff_badgeTracking inner join staff_badgeTrackingNew
On staff_badgeTracking.Badge_ID = staff_badgeTrackingNew.Badge_ID where badge_id = '1234'

[aktharshaik]

what is the error msg u r getting.

[aktharshaik]

if badge_id column a numeric, then omit the quotation marks for '1234'

[vb5prgrmr]

You may also have to prefix badge id with one of the two table names since you have an inner join on badge id.

Good Luck

[gingank]

You may also have to prefix badge id with one of the two table names since you have an inner join on badge id.

Good Luck

I don't understand what you said can you write the example for me and correct me on the sql statement

[vb5prgrmr]

WHERE staff_badgeTracking.Badge_ID = 1234

Good Luck