Is a nested query possible?
First part of the query would need to select distict sequence numbers from a production schedule (threre are mulitples).
ex. select distinct(seqno) from schedule;
The second part would need to count the number of different models (represented by the 30th digit of the model number) on the schedule.
ex select mid(model,30,1), count(mid(model,30,1)) from schedule group by mid(model,30,1);
On the schedule there are several duplicate sequence numbers, and each sequence number always has the same model number.
I tried to attach a sample file, but when I do the attachment my posting will not submit, so I pasted some lines from notepad in the comment field.