CREATE TABLE TableC SELECT tableA.field1,table1.field2,tableB.field1 FROM tableA,tableB WHERE joinCondition
That should do it, if I got the syntax correct. You do want to use the create/select combo though. On Thursday, September 26, 2002, at 12:59 AM, Jack wrote: > Dear all > i had two tables, tableA & Table B. > I want to create a permanent table call Table C which the first two > field > will be equal to Table A's first 2 field and last field will be equal to > Table B's first field. > > can anyone pls tell me what query should i use? > it will be nice if you can provide me a simple example! > > Thx > jack > [EMAIL PROTECTED] > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
