Home > Archive > MySQL Server Forum > November 2005 > Re: I need help with selecting from 2 identical tables in 2 separate









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: I need help with selecting from 2 identical tables in 2 separate
Bill Karwin

2005-11-18, 1:23 pm

phillip.s.powell@gmail.com wrote:
> Syntax error near "blah SELECT DISTINCT..." you can't apparently do
> "INSERT INTO [tableName] SELECT" in 3.23.58

Okay, then create the table in the conventional way, by listing all the
fields and datatypes. Then fill it with data using INSERT INTO blah
SELECT...

Regards,
Bill K.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com