Recent content by orreymalcolm

PERFECT, exactly what I want, thank you SO much gmmastros! I'm glad this is finally off my chest. KUDOS!

Hey guys, I have a table (AMAC) that I wish to update based on another table with similar columns (OldAMAC). The fields they have in common are the Agreement ID, Member ID and the Committed field. The reason I'm doing this is because one of the tables (the one I wish to reference to when...

Sorry, I forgot... gsd_hocm = "All Members and All Contracts" Table gsd_comr = All Contracts table gsd_hosf = All Members table *_agre_no = Contract ID *_memb_no = Member ID

Hey Guys, I'm writing a quick query to combine the results of 2 tables. One has contract information (with contract ID) another is Member information (with Member ID). I have a 3rd table which was passed down to me by the person I replaced. This 3rd table is an "All Members and All contracts"...

It was asking for parameters for everything in gsd_hocm all the "fm_" ones.

Member table is called gsd_hosf MemberID = ff_memb_no Contract table is called gsd_comr ContractID = fr_agre_no AllMember and Contracts table is called gsd_hocm MemberID = fm_memb_no ContractID = fm_agre_no Committed = fm_option

lol, Thanks, I'm not that oblivious I have the REAL ones in, but it still asks.

The Cross join gives me errors during runtime. It's asking for parameters. What do I do :(

No there is no index on them....Should I add an index?

Structure is as follows. Members Table: Member ID, Name, Address, etc Contract Table: Contract ID, Description, Created, Ending, etc All Members/All Contracts Table: Member ID, Contract ID, Expiry, Committed (A for Yes, B for No)

Hey PHV, I would do a cartesian, but my experience with it has gave me unwanted results, such as duplicating everything without member numbers, then adding some without, then putting them all together in a weird format. Everytime i use this type of join, i never get the desired results. Is...

Hey Everyone, I have 3 Tables. <Complete Contract List> - lists all the contracts available (2011 records) <Member list> - List all member information (657 records) <Complete List of Members and contracts> - Has a listing of every member and every contract that those members are committed...

Hey everyone! I am currently working on a database with 3 Tables. 1 is the customer list (657) with all their details, 1 is a contract list (2011) with all those details and the 3rd is a complete customer list with all the current contracts they are committed to (486,974). What I need to do is...

Hey Crowley! thanks for the response, it seems like it will work, I won't be able to tell until i add my append. I wanted your opinion on my code to append. currently it will be something like this INSERT INTO <members-and-contracts> (<agreementNUM>, <memberNUM>) SELECT <agreementNUM>...

Hello, I am currently working on database where I need to compare 2 tables with each other and see which data in table 1 is not already in table 2. Table2 has a mix of data sorted by an ID number and table 1 is sorted by a another type of ID code. The problem lies here. Table 2 needs to have...