You might want to append table to table.. in this case you should use UNION (not JOIN).. but if you got 2 identical tables of type MyISAM, then you can define a MERGE table like this:
CREATE TABLE new_table (*table definition of the original tables*) type=MERGE union=(all_by_Payroll,payinc); then you can run the select query on the new_table. "Unknown Sender" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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]
