March 29, 2011 at 3:18 pm
Good afternoon
please necito query a guide, I am developing an application portfolio, my intension is that the bills that are being paid by a client such invoice is not displayed more in the portfolio module.
many thanks
March 29, 2011 at 3:23 pm
jhors_g (3/29/2011)
Good afternoonplease necito query a guide, I am developing an application portfolio, my intension is that the bills that are being paid by a client such invoice is not displayed more in the portfolio module.
many thanks
I'm assuming this isn't an early April Fool's joke. Jhors... how would we be able to help you build a query having no idea what your tables look like, what data is in them, or what you've developed so far?
Are you looking for introductory materials to doing T-SQL? Google: T-SQL tutorial to get started.
Otherwise, please go into the first link in my signature below and it will show you how to provide data and structure (DDL) for us to be able to help you.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 29, 2011 at 3:35 pm
Craig Farrell (3/29/2011)
I'm assuming this isn't an early April Fool's joke. Jhors...
ROFL :hehe: :hehe:
March 29, 2011 at 4:23 pm
Ok, thank you very much for your answer, you're right.
well, I have 3 tables in sql, a bill called, detallefactura and abonofactura, what I do is this to show invoices that have a client.
SELECT DISTINCT tblFACTura.intCodigo_FACT, intNumero_FACT AS [INVOICE NUM] dtmFecha_FACT AS [DATE INVOICE] AS dtmFechaRadicado_FACT FECHA_RADICA,
dtmFechaVenc_FACT AS [MATURITY DATE] AS CUSTOMER tblCLIEnte.strNombre_CLIE
TblDetalle tblFACTura FROM INNER JOIN ON
tblDetalle.intCodigo_FACT = tblFACTura.intCodigo_FACT
INNER JOIN ON tblFACTura.intCodigo_CLIE = tblCLIEnte.intCodigo_CLIE tblCLIEnte
ON LEFT JOIN tblABonoFActura
tblABonoFActura.intCodigo_FACT = tblFACTura.intCodigo_FACT
WHERE tblFACTura.intCodigo_CLIE = @ intCodigo_CLIE
ORDER BY intNumero_FACT,
semcilla is a query, right?? ok, when a customer makes a payment to the invoice or pay the entire amount of fertilizer in the table equals abonofactura wing must equal the sum of detallefactura, thus earned the invoice was canceled by the customer , which is what I intend to consultation, is that every time I load an invoice to a client this is seen in module portfolio, when the user adds a subscription or assigned by the total value of the bill this bill is not load more in the portfolio module.
I hope this time I can help.
many thanks
March 29, 2011 at 5:01 pm
jhors_g (3/29/2011)
Ok, thank you very much for your answer, you're right.well, I have 3 tables in sql, a bill called, detallefactura and abonofactura, what I do is this to show invoices that have a client.
You did not read the article. This doesn't give us structure or data to work off of, so all we will be able to do is give you generic advice.
SELECT DISTINCT tblFACTura.intCodigo_FACT,intNumero_FACT AS [INVOICE NUM] dtmFecha_FACT AS [DATE INVOICE] AS dtmFechaRadicado_FACT
FECHA_RADICA, dtmFechaVenc_FACT AS [MATURITY DATE] AS CUSTOMER tblCLIEnte.strNombre_CLIE
TblDetalle tblFACTura FROM INNER JOIN ON
tblDetalle.intCodigo_FACT = tblFACTura.intCodigo_FACT
INNER JOIN ON tblFACTura.intCodigo_CLIE = tblCLIEnte.intCodigo_CLIE tblCLIEnte
ON LEFT JOIN tblABonoFActura
tblABonoFActura.intCodigo_FACT = tblFACTura.intCodigo_FACT
WHERE tblFACTura.intCodigo_CLIE = @ intCodigo_CLIE
ORDER BY intNumero_FACT,
Please note the use of the code tag there, makes things easier to read (you can see it if you just click quote, you'll see exactly what I used there). This query won't run as is, so it's obviously incomplete. For example: FROM INNER JOIN will fail syntax. ORDER BY intNumero_FACT, will fail, having only one item in the order by.
Thus, we're going to make some assumptions from this, as it's not a complete statement.
semcilla is a query, right??
Sure, if you say so. I only speak English so I'm doing my best to follow along here. 🙂
ok, when a customer makes a payment to the invoice or pay the entire amount of fertilizer in the table equals abonofactura wing must equal the sum of detallefactura, thus earned the invoice was canceled by the customer , which is what I intend to consultation, is that every time I load an invoice to a client this is seen in module portfolio, when the user adds a subscription or assigned by the total value of the bill this bill is not load more in the portfolio module.
Slow this down, please. You're very familiar with this database and we're not. What do you mean by this: equals abonofactura wing? Also, when it equals the sum of detallefactura, what is it summing on? There are no group bys in your above example.
I'm afraid I really don't understand the rest of what you're trying to do there. I think we're having language and coding difficulties simultaneously, and I'm sorry for that.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply