0

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'

3
Contributors
5
Replies
6
Views
7 Years
Discussion Span
Last Post by vb5prgrmr
0

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

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.