thanks for the replies. sorry for the delay in replying. i am having 8 different lookup tables which contains the master list of all the materials.(endmills, gauging instruments, drills,tooling systems, etc).these contain the material name and respective product id's. there is another table which iam using for issuing material and tracking their usage. this table contains the product ids of all the material issued and the their respective qty.
NOW my real problem is i want to show the name of product instead of (OR ALONG WITH) their product ID's. but i am not able to join all these tables together. therefore i was considering of creating a temporary table which contains all the product ids and their desc pulled from the lookup tables and join it with material issue table. i hope iam not confusing you guys. On Jul 23, 3:31 pm, Fran <[email protected]> wrote: > On Jul 23, 7:12 am, Vidul Petrov <[email protected]> wrote: > > > > That's why the question was asked: what do you need to do exactly? > > db._execute('CREATETEMPORARYTABLEtmp (id INT)') > > # or whatever the SQL server's dialect requires > > This isn't what you're trying to achieve. > This is a proposed way of achieving it. > > F --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
