Finding all Childless Parent Records v. 3.32

Hi all, I have a table: id, name, parent_id I need to find all records that have no children. I know how to do it using a sub select, but I need to do this in version MySQL 3.32 and I am not sure how. Thanks, Charles -- RightCode, Inc. 900 Briggs Road #130 Mount Laurel, NJ 08054 P: 856.

Trying to understand the license

Hi all, I am still a bit confused as to the license for using MySQL. If I create an application in PHP, that uses a MySQL database (for example a shopping cart application) and I want to sell this application (not open source), am I required to pay a license fee? I found this quote: "2. Free

Re: SUM() not working as expected

Wow... ROLL UP looks great! Thanks. - Charles On Mar 4, 2004, at 5:28 AM, Victoria Reznichenko wrote: charles kline <[EMAIL PROTECTED]> wrote: Oh I see... so how would I get balance_amt to have a running balance? - You can calculate it in your application - You can run an additional

Re: MySQL SELECT problem

sub selects are only in 4.1 I thought? On Mar 3, 2004, at 5:08 PM, Jacque Scott wrote: Also you can have subselects in 4.0. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SUM() not working as expected

Oh I see... so how would I get balance_amt to have a running balance? Thanks, Charles On Mar 3, 2004, at 11:20 AM, Victoria Reznichenko wrote: charles kline <[EMAIL PROTECTED]> wrote: Hi all, Just trying to figure out why the SUM() in this query is not returning the sum, but is returni

SUM() not working as expected

Hi all, Just trying to figure out why the SUM() in this query is not returning the sum, but is returning the same value that signed_amt contains. Anyone have a clue? Thanks for any help :) Here are the results I am getting: id | signed_amt | balance_amt | entry_dtm ---++---

Re: Need help with ledger type query

ly worn, and loudly proclaiming: "WOW! What a ride!" -----Original Message- From: charles kline [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 10:50 AM To: [EMAIL PROTECTED] Subject: Need help with ledger type query Hi all, I have 3 tables: tbl_users id | user ---

Need help with ledger type query

Hi all, I have 3 tables: tbl_users id | user --- 1 | charles tbl_ins id | in |date|user 1 | 100.00 |timestamp |1 2 | 50.00 |timestamp |1 tbl_outs id | out|date|user

When to use NULL as default value

Hi all, I pretty much set a fields default value to NULL if it not a "required" field in my app. Just wondering if this is the way to go since I just sort of guessed at this method ;) - Charles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

Join Question

I have two tables. tbl_reports and tbl_personnel tbl_reports has these fields: rep_id, person1, person2, person3, person 4 tbl_personnel has these fields: per_id, fname, lname, mname What is the way to get each report back once, and have the fname, mname, and lname fields available to print

Newbie in over their head ;)

Hi all, I posted about this late yesterday and got some help, but I am really stuck now. I need to display my results to the web using PHP. Here is my query: SELECT p.lname,p.fname,p.degree1,p.degree2,p.degree3, w.web_link, a.dra_id, dra.area, t.title, id.interest_id, i.

Query help needed please

Hi all, I am fairly new to SQL and this is a really complex query for me. Here is the setup. 3 tables. tbl_personnel, tbl_personnel_dras, tbl_dra each person in the tbl_personnel table can have 0 - 3 records in the tbl_personnel_dras table. The tbl_personnel_dras table is just the person_id (fro

Re: Newbie Query Question

tbl_people.id = tbl_peoples_interests.person AND tbl_people_interests.interests.id = interests.id -jeff On Sat, 2003-03-15 at 09:23, Charles Kline wrote: Hi all, My first post to this list. I have a query which I can't quite get to work. I was hoping that someone here could educate me

Newbie Query Question

Hi all, My first post to this list. I have a query which I can't quite get to work. I was hoping that someone here could educate me a bit. I have two tables. tbl_people | id| fname|lname| --- | 1 |frank |smith | t