trying to write a sql statement, using 8 tables, linking between them all with a hangover from hell. not good
Ian
Printable View
trying to write a sql statement, using 8 tables, linking between them all with a hangover from hell. not good
Ian
And this is the finished result (8 tables - was a bit of an exageration)
Code:SELECT conenv.Aircon_asset_num, conenv.Serial_number, manu.Manufacturer, aircon.Model, conenv.Env_id, site.Town_City, site.Site_name
FROM tblAircon_env as conenv, tblAircon as aircon, tblManufacturer as manu, tblenv as env, tblSite as site
WHERE conenv.Aircon_id = aircon.Aircon_id AND aircon.Manufacturer_id = manu.Manufacturer_id
AND conenv.Env_id = env.Env_id AND env.Site_id = site.Site_id
Eassshy, hic!
Cheers, literally,
P.
I'm not as think as you drunk am i
Can you even get that drunk on sherry?
it was the staff christmas party last night and i managed to polish off 1 bottle of white, 4 pints of cafferey's and 3 southern comforts. as you can tell from that, i'm not feeling too hot today
Whoa Dude outstanding!!!!!! Move down to Oz, your sort are always welcome.:)Quote:
Originally posted by Ianpbaker
it was the staff christmas party last night and i managed to polish off 1 bottle of white, 4 pints of cafferey's and 3 southern comforts. as you can tell from that, i'm not feeling too hot today
Well go to log. Adding an Exceptions window to a Purchase Order Receipt function today. Man, does the fun ever stop!
We have ours on Saturday night, we try to match your outstanding record.....not that l will mean too at the start of the evening of course....but well we always start with tequilla laidbacks and get roaring after those. LA Dave is in for a lot of trouble...this will be his first expierance....and he will not be getting friggin wine coolers. I thought those things had gone out of fashion, but he tends to front with them from some supplier.
White what? Spirit? Prefer meths meself, that purple glow...Quote:
i managed to polish off 1 bottle of white...
Cheers,
P.
your a funny man paul, I think you might have been watching to much bottom
I get far too much telly in.
You are a pretty funny guy yourself, amazing how we both get funnier, the more beer we drink though...
Cheers,
P.
well, it is the season of good will. I've got four christmas party's to do this year (already had two). it's a hard life, but someone's got to do it
If you need a hand...:)
P.
unfortunatley, the drinks are all mine. be warned never come between me and a pint, wars are more pretty ;)
I was going to make the obvious wise crack here, but decided the jokes wearing abit thin.Quote:
Originally posted by Ianpbaker
unfortunatley, the drinks are all mine. be warned never come between me and a pint, wars are more pretty ;)
Oh what the hell, a final one for the road
I wouldn't want to touch your pint of sherry:):):)
Ok that's it no more sherry jokes....will not mention it again...will completely remove the s word from future posts.
your so kind jethro
Well...he said he wouldn't mention it......but that never stops the rest of us ;)
Amontillado :) (And I can't spell...end of term and I've been celebrating - actually, been celebrating since thursday :))