Re: One query, different tables?

Why do you have to tables with products? Couldn't you have a type or category column and then have to only query one table? Bastien On Fri, Aug 9, 2013 at 11:52 AM, Niel Archer <not@chance.now> wrote: > > Hello. > > I am newbie in this and need som basic help. > > > > I have a form witch checkbox'es with different serialnumbers. > > The serialnumbers reflect different products and every product category > > have their own tables. > > This sounds like a database design question more than a PHP one. > > > > > I can transfer items from store to truck but can't transfer them back to > > store. > > I have 4 stores and like to transfer products between this. > > > > I like to to it like this: > > store_one -> truck_document -> store_two > > > > But how can I transfer both Dynamite and Exan in one query to their > > respective tables? (One table is named exan and the other dynamite.) > > > > Thank you very much for your help. > > > > I have been searching google but can't find anything about this question. > > > > Karl > > -- > Niel Archer > niel.archer (at) blueyonder.co.uk > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Bastien Cat, the other other white meat