JOIN Field

What is the purpose of field that are listed after JOIN clause in SELECT statement? For example, is it proper to write: SELECT * FROM CustTable WHERE CustTable.AccountNum == “Img” JOIN * FROM CustTrans WHERE CustTable.AccountNum == CustTrans.AccountNum && CustTrans.Status == ‘P’ What could I user instead of * after JOIN clause?

hi I think your example is correct, but you could write it in this way as well: SELECT CustTable WHERE CustTable.AccountNum == “Img” JOIN CustTrans WHERE CustTable.AccountNum == CustTrans.AccountNum && CustTrans.Status == ‘P’ You can write specific fields instead of * … join tablefield1, tablefield2 from table where … I presume that this can work faster if your table is very large and you have many table fields Slawek