Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by piyushmittal
-
searching multiple tables w/same fields
Prefix each fieldname in your SELECT with the table name.<br> <br> For example : If your table names are CUSTOMER and EMPLOYEE.<br> <br> SELECT CUSTOMER.name, EMPLOYEE.name<br> FROM CUSTOMER, EMPLOYEE<br> WHERE CUSTOMER.id = EMPLOYEE.id;<br> <br> will give you the name of each employee who is...- piyushmittal
- Post #2
- Forum: ANSI_SQL
