[Squirrel-sql-users] How to make a query with WHERE

[Leo W. <lw...@we...>]

Hi,

I'm aware that I can just type in my SQL command, e.g.


SELECT property_id FROM property where property_key=12


Is there an easier solution to get the same result with just restricting 
to '12'? In PHPMyAdmin I have a mask where I can simply set the 
parameter I want to restrict.

To my understanding it seems promising to do it with Graph-table but I 
don't see a way how to add just the restriction to 'property_key=12' 
into the WHERE clause. As soon as I switch from the 'SELECT' to the 
'WHERE' tab forth and back the content of the WHERE is gone.

Any other ideas?


kr

leo

-- 
*Weberhofer GmbH*
information technologies 	*DI Leo Welsch*
Software Entwicklung

Blindengasse 52/3
1080 Wien
Austria 	+43 (0)1 5454421 <tel:+4315454421>
www.weberhofer.at <http://www.weberhofer.at>
UID: ATU55277701, Firmenbuch: 225566s, Handelsgericht Wien