[SQL] Using variables in select

2011-08-12 Thread tlund79
Hi, Firstly; I'm not a developer, but a business developer and statistics guy. This means that I'm happy using "basic" selects to gather information for analysis. One thing that could really efficiate my work is using variables, let's say I have a table with different orders; |customer_id|produc

Re: [SQL] Using variables in select

2011-08-12 Thread Oliveiros d'Azevedo Cristina
How do you access your database? Through some client application like psql ? Through some other mean? The query you included is the query you wanna perform against ur table? Or was it just an example? Do you wanna avoid having to write the complete query on the command line? If so, you sound li