I need to write a sql statement that will retrieve records from one table and add a boolean field if the record customerid exists in a second table. Example:
Table1 fields CustomerID,CustomerName Table 2 field CustomerID
I want the sql statement to be something like:
Select table1.CustomerID, table1.CustomerName, table1.IsInTable2
From Customer InnerJoin Table2 on table2.CustomerID
Thats pretty much guess work on my part but I hope it conveys enough information.