I can't work out why this doesn't work as I'm sure I usually use joined columns to join to other tables.
In essence I mean i will select...
Hi Zargon, thanks for your help with my queries I have posted. I have a job where I am flitting between different projects so when i return to...
Thanks for the quick reply.
I have been working on the query this morning and will paste the code below.
Unfortunately i am getting...
Hi I need to check various columns of a particular table to see if they are not really being populated or the data is always the same. So that we...
Hi Zargon, thanks! I thought it was a syntax issue.. I was using pl SQL more frequently previously but the nature of my work means I haven't used...
Yeah the query is working fine. I need to automate that query though through a for loop so that it runs that query for each guide in...
Ok thanks Zargon
oh the guid in my query in the previous post is just one i was using at the time so will likely not be present in the 2 tables of data i provided.
and here is my sql query..
WITH ROB AS (
MAJORELEMENTCODE, MAJORELEMENTNO, MINORELEMENTCODE, MINORELEMENTNO, ELEMENTMATERIAL
To summarise what I was trying to do:
I have 2 tables:
Element table script:
OK ill provide more info, hopefully tonight.. Thanks Zargon
I have now tried this but its not working.. is this along the right lines?
FOR RRR IN (select DISTINCT guid FROM TEMPLATE)
I have written a query that essentially unions a new set of data with a previous set of data for a bridge examination.
I need to do this for...