MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Daniel Bondurant Date:April 21 1999 11:32pm
Subject:searching two tables
View as plain text  
A Basic question:
I need to search though two tables for a match.
I don't need to search for a match between the two tables.

something like
select bar from table_1, table_2 where a='foo';

I know I need to make an alias table to combine the two tables into one,
and then select from the combined table, but I do not know how.

Turn off your computer and go outside
searching two tablesDaniel Bondurant22 Apr
Re: searching two tablesElton Hughes22 Apr