Select statement

[Darryl Hoar]

Greetings,
I am just trying to wrap my brain around joins.

I have a table employee.  For each record in employee, I want to see
if a record exists in table emp2 based on a field value in both tables.  IE,

for each employee
  for each emp2
     if employee.field1 = emp2.field3 then
        do something interesting.
   end emp2 loop
end employee loop.


can someone point me to the right join syntax to get this done ?

thanks,
Darryl


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]