IanBradshaw
Member²
Whenever I'm trying to use an inline view query, as soon as I type the tables alias name then . to get the list of fields pl/sql developer freezes and I have to ctrl + alt + delete to shut down the program. This happens in both the sql window and command window. The query I'm running is as follows.
SELECT query1.jcategory
, query1.tot_insp
FROM jpost_insp c
,( SELECT a.jcategory
, COUNT(DISTINCT b.rowid) tot_insp
FROM jjobh a
, jdocument b
WHERE a.jclcode = 'PPP'
AND a.jjobno = b.jjobno
AND b.sign_off_code IN ('77', '99', '80')
GROUP BY a.jcategory ) query1
WHERE c.jcategory = query1.jcategory
SELECT query1.jcategory
, query1.tot_insp
FROM jpost_insp c
,( SELECT a.jcategory
, COUNT(DISTINCT b.rowid) tot_insp
FROM jjobh a
, jdocument b
WHERE a.jclcode = 'PPP'
AND a.jjobno = b.jjobno
AND b.sign_off_code IN ('77', '99', '80')
GROUP BY a.jcategory ) query1
WHERE c.jcategory = query1.jcategory
