parsed.org

Tips by tag: comments

Building SQL in Query Tools by xinu on Jan 03, 2008 01:47 PM

You've got to build a query, but you're going to need bits of data from previous queries to do it. As you run the smaller queries, note the interesting value returned as a comment on the same line for use later:

select id_job from jobs where name like = '%foo%' -- 41319
select id_jobentry from jobentries where id_job = 41319

Thanks to McG for the tip.

aquacommentsqueriesquerysqltools
RSS