[join] Forum Topics

I have three tables that I query. Problem is my ORACLE MIF table has 500,000 rows. And it takes more than 1 hour. How can I reduce the time? SELECT WB_FIELD_REQ.MODEL, WB_FIELD_REQ.MFG_SERIAL_NUMBER, CONFIG_SERIAL_NUMBER, SH_CONTRACTS.EQUIPMENT_ID, "", SH_CONTRACTS.SERVICE, "", SH_CONTRACTS.CONTRACT, "X", "", "X" FROM WB_FIELD_REQ INNER JOIN SH_CONTRACTS ON WB_FIELD_REQ.MFG_SERIAL_NUMBER=SH_CONTRACTS.MFG_SERIAL_NUMBER NOT IN …

hi my name is vishal for past 5 days i have been nuts of how to combine data from multiple tables into single table using sql select query (join query) Given below i have tried solution but i get error message data not found. But in table i have datas …

i have two dbf that should write in excel file,,ive already done writing on the first table my problem is how can i join the other table from the other but theyre not going to combine,,first table id in the upper part and the second table is in lower part,,

I managed to duplicate a single record. However I intended to display the duplicate record with different values. For example: A ABC 065 001 A10111 Sell 54.847500 0 0 T ABC 065 001 A10111 Sell 50.847500 0 1 [CODE] SELECT case i.ordStatus when 'Queued' then 'N' when 'Filled' then 'A' …

I am creating a cms, where I have a Global horizontal navigation(SUBJECTS) in the top, and a local navigation(PAGES) on the left, all database driven. First I decide if either a subject or a page has been set, to display the correct information: [CODE] if (isset($_GET['sid'])) { $subjectid = ($_GET['sid']); …

Hi, I'm joining 2 tables and using the formview. When I insert a record, I need to place the value of the max id + 1 of the second table in a field in the first table so that the tables are linked. I'm not sure where to put the …

Im trying to add new records to my joins table. but when ever i click my link to do so i get this error [QUOTE]uninitialized constant Channel::UsersChannel[/QUOTE] here is the code [CODE] <%= link_to "Subscribe to Channel", subscribe_path(channel, current_user) %>[/CODE] [CODE] def subscribe @channel = Channel.find(params[:channel_id]) @user = current_user @channel.users …

hi! i have little problem with left join below script working but i want to add restriction field_id = 16 (any value) and user_id = 65 (any value) pls help me how to do this [CODE]id user_id field_id value[/CODE] [CODE]<?php $dbHost = "localhost"; $dbUser = "root"; $dbPass = "123"; $dbName …

Hi I have a query which i run to give me the monthly amount of money that needs to get loaded to our consultants cards. Our system has changed and I need to get the same data but differently The query needs to join three tables consultants,voucher,gift_cards. The only difficulty …