Hi All I know there are similar postings out there, but when I have tried to use any of them in my own query I can not get it working. Basically, I have 3 tables that I want to query in ACCESS using the SQL view. Initially though and for this example I am trying to do it with just the 2. tb1 name: Tasks tb1 fields wanted: Task ID Ta...
I have a library of different words/phrases, and in order to build sentences at present I add a combination of these phrases into a playlist to make a sentence. Unfortunately if the user is running cpu intensive applications (which most of my users are) there can be a lag of a few seconds mid-sentence (in between phrases). In order to ...
I want to join 2 tables together but i cant get it to work. These are the tables: threads: id, title posts: thread_id, message $sql = mysql_query("SELECT threads.id, threads.title FROM threads JOIN posts ON posts.thread_id = threads.id WHERE threads.id = ".intval($_GET['id']))...
Doing some refactoring in some legacy code I've found in a project. This is for MSSQL. The thing is, i can't understand why we're using mixed left and right joins and collating some of the joining conditions together. My question is this: doesn't this create implicit inner joins in some places and implicit full joins in others? I'm of ...
I'm having trouble thinking of a way to do the following join in MySQL. I'm not sure which joins would be best suited for this task, so I'll edit the title when someone points it out. Here's the gist of what I'm trying to do. I have two tables, call one Students, and the other Marks. They are setup as follows, Students Only the Id ...
I've been furiously googling trying to figure this out, with surprisingly little luck; I would guess this is a common issue. I have 5 tables: orders, addresses, notes, transactions, line_items, and shipments. transactions, addresses and notes all have indexed order_id fields - line_items and shipments have indexed transaction_id fields...
I have 4 Tables in my SQL server DB . OrderMaster,OrderDetails,ItemMaster,ManufacturerMaster OrderMaster ( OrderId [primaryKey],Orderdate,TotalAmount,SupplierName) OrderDetails (OrderDetailId[primaryKey],OrderId,Item_Id,Quantity,ManufacturerId) ItemMaster (Item_Id [primaryKey],ITem Name,ITemCost,) ManufacturerMaster (ManuId[primaryKey],...
I use codeigniter, and I need to get data from 2 different table. for now it returns data only from works_image table. how can I get data from both 2 table ? thanks a lot!! $this->db->select('works_image.*', 'works.*'); $this->db->from('works_image', 'works'); $this->db->join('works', 'works.id = works_image.id_work'); $result = $thi...
I have a problem selecting from a link table and filtering out superfluous results. Publications belong to packages by means of the package_publications table. For instance, I know the ids of my publications to be 11 and 47. I want to return a package that has ONLY those publications in it. Now if I do a join and do something like whe...
I have a simple many to many relationship and I am wondering how you get data out of it. Here is the setup Tables Media Media_Keyword (many to many map) Keyword Here is the code I have: public List<Keyword> GetFromMedia(int mediaID) { var media = (from m in Connection.Data.Media where m.id == media...
Hi there, I'm trying to create an association between two models using join conditions rather than a foreign key. Does anyone know if this is possible? For example I want to join products to pricing points. A product has a price and a pricing point has a minimum and maximum amount and a name. Eg. Min = 0, Max = 20, Name = Less than $20...
Hi, I have a true dailyWTF on my hands here. We have an account sign up page that dishes out new account numbers in sequential order. The problem we have is two fold. For one we had customers that already have customer IDs sign up for another customer ID. To solve this we added a "Current Customer ID" field to the form so they could ent...
Hello, I'm trying to join two tables. The first table has a list of 11 items which are 'site_names' with an auto id field of 'id'. The second table that I want to connect has an auto id field of 'desc_id' and another field of 'descriptions'. This second table currently has 3 rows of data that I want displayed only for id 1 in table 1. ...
What am I missing? I need to return all records that match the Last_Name Query whether they do or do not have a Customer Number in the Field_Table. I am calling the Client table twice because each client Id has a parent whose contact number = 0. I need the parent record to return the city, state, zip and company name. I have tried loo...
I am building a view in SQL Server 2000 (and 2005) and I've noticed that the order of the join statements greatly affects the execution plan and speed of the query. select sr.WTSASessionRangeID, -- bunch of other columns from WTSAVW_UserSessionRange us inner join WTSA_SessionRange sr on sr.WTSASessionRangeID = us.WTSASessionRang...
What's the difference between using oracle's plus notation over the ansi standard 'join' notation? Is there a difference in performance? Is the plus notation deprecated? Thanks ...
Hi all LEFT JOIN teams ON teams.id = (SELECT team_id FROM auth_users WHERE id = offers.user_id) Gives me all the columns of the teams table, but converts everything to NULL. LEFT JOIN teams ON teams.id = 1 works like a charm When i do SELECT (SELECT team_id FROM auth_users WHERE id = offers.user_id) as team_id team_id will be ...
I have a field called PropertyValue in the UserProfile table that can contain information for address, phone number, first name, last name, user name, city, etc... each record in this table is associated to a user by UserId, it is also associated to a ProfilePropertyDefinition which contains the definition for each of the properties (ie....
Hi, I'm trying to create a simple poll function using php and sql. I have three tables: Questions Which simply contains each question asked question_id | question_text | created_at Answers Which contains each answer for each question question_id | answer_id | answer_text Answered Questions Which records who has voted for each opt...
What I mean is, If I had the following schema: create table tableA( A_id number not null primary key ); create table tableB( B_id number not null primary key, A_id number not null references tableA(A_id), B_data text not null ); create table tableC( C_id number not null primary key, A_id number not ...