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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]