Hi - I need assistance using the max condition in SQL. When I run the below sql query (App 1) I have returned the table of information displayed in (App 2) App 1: SELECT a1.group_code, a1.prod_code,...
Hi, I've been on holiday the past two weeks and unfortunately this morning my video recorder chewed up the recording someone had recorded for me...... Would someone be so kind to give me a brief...
Hi, I am currently working in a team that contain the most dull, boring and biggest two faced bitches i've ever worked with. Today is my last day and i really want to write them a snotty (yet witty)...
i, I need to link a table to my below query using an INNER JOIN. The table I need to join is called (CIT SPOT) and the field I'm joining is Src_prod_ofr_no (as this is in both CIT_SPOT and...
Hi, I asked for help from you guys with an SQL query yesterday and someone replied and helped really helped me, I was given the following query select T1.src_prod_ofr, T1. source_code, T2.cit_code...
SQL question for you....... Table A has 110,000 records Table B has 15,000 records When I join table A to table B I only receive 15000 records back (them being original data from Table A matched with...
I have an access database that has had it's file path changed. Now when I try to open the certain tables in the database they won't open, Can anyone please help me get round this? (thinking you need...
Last week on Radio 1, Laura (I think) said anyone can soud good these days when singing (she was reffering to Paris Hiltons new song) The Radio1 team then challenged her to do better and in all...
Hi, I'm currently putting together my family tree..... I'm struggling to find the name of my grandad's mother. I know her maiden name but can't find her first name anywhere? Can anyone suggest a place...
Hi, I'm interested in looking at my family and family history but not sure where to start. I've been on a few family tree websites but there always too expensive. Does anyone know any free websites to...
It's annoying me who sings a certain song..... It's out now (a new song) their an american rock group, the video is with kind of gimpy lad who takes a girl to the prom, it's basically the band in...
Hi, Does anyone know any shops that are selling beer pools (you know ? large pools that you can fill with ice to keep your beer cool?) If so, how much are they charging?Thanks
Hi, I'm having a birthday party on June 10th straight after England's 1st game (good luck lads)I want to burn some classic party tunes to CD but for my life I can't think of any, my minds gone...