Variables passed

[netbar]

if I have a select statement which basically does a
select * from x where y='&1';
Where x has many referencial tables in which I would like the variable passed to y to be used!

What's the best way to build this into a sql statement, how do I pass the value inputted into '&1' further down within the script!

Hope this is clear!!

Many thanks

[pando]

instead of &1 use &&1

[netbar]

Thanks!