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 :))