things not to do

[Ianpbaker]

trying to write a sql statement, using 8 tables, linking between them all with a hangover from hell. not good

Ian

[Ianpbaker]

And this is the finished result (8 tables - was a bit of an exageration)

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

[paulw]

Eassshy, hic!

Cheers, literally,

P.

[Ianpbaker]

I'm not as think as you drunk am i

Can you even get that drunk on sherry?

[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

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

Whoa Dude outstanding!!!!!! Move down to Oz, your sort are always welcome.

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.

[paulw]

i managed to polish off 1 bottle of white...

White what? Spirit? Prefer meths meself, that purple glow...

Cheers,

P.

[Ianpbaker]

your a funny man paul, I think you might have been watching to much bottom

[paulw]

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.

[Ianpbaker]

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

[paulw]

If you need a hand...

P.

[Ianpbaker]

unfortunatley, the drinks are all mine. be warned never come between me and a pint, wars are more pretty

Originally posted by Ianpbaker
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.

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.

[Ianpbaker]

your so kind jethro

[parksie]

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 )