Table Joins Date: Sun, 11 Jan 2004 18:18:31 -0000

Hi,

I have 2 identical tables and wish to join them. I am a complete novice and
thought it was simple!

Here is the code that I am using with asp.net

select Date, Payroll, First, Last, Rank, Number, Division, Reason, ImpDate
from all_by_Payroll, payinc where "+ DropDownList1.SelectedItem.Value + " =
'" + TextBox1.Text +"' ORDER BY Date ASC"; 

Any help would be appreciated as I am now completely stuck

Thanks,

Simon