Hi SET,
Just for you my Friend... Please check...
CREATE TABLE BOOK_SELLING_DETAIL( BOOK_NO Integer, BOOK_ID Integer,
PUBLISHER Varchar(50), MAIN_BRACH Varchar(10), PUBLISH_DATE Date,
ORIGINAL_PRICE Float, SELLING_PRICE Float);
INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID, PUBLISHER, MAIN_BRACH,
PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY") VALUES ('5', '222',
'Willy', 'Branch1', '25.01.2010', '550.000000', '500.000000',
'00000086:00000001');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID,
PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY")
VALUES ('5', '333', 'Willy', 'Branch1', '25.01.2010', '450.000000',
'400.000000', '00000086:00000002');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('5', '777', 'Willy', 'Branch1', '25.01.2010', '300.000000',
'250.000000', '00000086:00000003');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('5', '555', 'Willy', 'Branch1', '25.01.2010', '900.000000',
'800.000000', '00000086:00000004');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('5', '111', 'Tata Mcgraw Hill', 'Branch1', '25.01.2010',
'750.000000', '700.000000', '00000086:00000005');INSERT INTO
BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE,
ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY") VALUES ('5', '666', 'Tata Mcgraw
Hill', 'Branch1', '25.01.2010', '250.000000', '200.000000',
'00000086:00000006');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID,
PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY")
VALUES ('6', '888', 'Tata Mcgraw Hill', 'Branch1', '25.01.2010', '600.000000',
'500.000000', '00000086:00000007');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('6', '999', 'Tata Mcgraw Hill', 'Branch1', '25.01.2010',
'400.000000', '350.000000', '00000086:00000008');INSERT INTO
BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE,
ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY") VALUES ('5', '222', 'Willy',
'Branch2', '25.01.2010', '550.000000', '500.000000',
'00000086:00000009');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID,
PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY")
VALUES ('7', '333', 'Willy', 'Branch2', '25.01.2010', '450.000000',
'400.000000', '00000086:0000000a');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('5', '777', 'Willy', 'Branch2', '25.01.2010', '300.000000',
'250.000000', '00000086:0000000b');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('7', '555', 'Willy', 'Branch2', '25.01.2010', '900.000000',
'800.000000', '00000086:0000000c');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('9', '111', 'Tata Mcgraw Hill', 'Branch2', '25.01.2010',
'750.000000', '700.000000', '00000086:0000000d');INSERT INTO
BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE,
ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY") VALUES ('9', '666', 'Tata Mcgraw
Hill', 'Branch2', '25.01.2010', '250.000000', '200.000000',
'00000086:0000000e');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID,
PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY")
VALUES ('5', '888', 'Tata Mcgraw Hill', 'Branch2', '25.01.2010', '600.000000',
'500.000000', '00000086:0000000f');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('5', '999', 'Tata Mcgraw Hill', 'Branch2', '25.01.2010',
'400.000000', '350.000000', '00000086:00000010');INSERT INTO
BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE,
ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY") VALUES ('6', '222', 'Willy',
'Branch1', '30.01.2010', '650.000000', '600.000000',
'00000086:00000011');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID,
PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY")
VALUES ('6', '333', 'Willy', 'Branch1', '30.01.2010', '750.000000',
'700.000000', '00000086:00000012');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('7', '777', 'Willy', 'Branch1', '30.01.2010', '400.000000',
'350.000000', '00000086:00000013');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('7', '555', 'Willy', 'Branch1', '30.01.2010', '800.000000',
'700.000000', '00000086:00000014');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('8', '111', 'Tata Mcgraw Hill', 'Branch1', '30.01.2010',
'750.000000', '600.000000', '00000086:00000015');INSERT INTO
BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE,
ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY") VALUES ('8', '666', 'Tata Mcgraw
Hill', 'Branch1', '30.01.2010', '250.000000', '100.000000',
'00000086:00000016');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID,
PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY")
VALUES ('8', '888', 'Tata Mcgraw Hill', 'Branch1', '30.01.2010', '600.000000',
'400.000000', '00000086:00000017');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('9', '999', 'Tata Mcgraw Hill', 'Branch1', '30.01.2010',
'400.000000', '250.000000', '00000086:00000018');INSERT INTO
BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE,
ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY") VALUES ('6', '222', 'Willy',
'Branch2', '30.01.2010', '650.000000', '600.000000',
'00000086:00000019');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID,
PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY")
VALUES ('6', '333', 'Willy', 'Branch2', '30.01.2010', '750.000000',
'700.000000', '00000086:0000001a');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('7', '777', 'Willy', 'Branch2', '30.01.2010', '400.000000',
'350.000000', '00000086:0000001b');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('7', '555', 'Willy', 'Branch2', '30.01.2010', '800.000000',
'700.000000', '00000086:0000001c');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('8', '111', 'Tata Mcgraw Hill', 'Branch2', '30.01.2010',
'750.000000', '600.000000', '00000086:0000001d');INSERT INTO
BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE,
ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY") VALUES ('8', '666', 'Tata Mcgraw
Hill', 'Branch2', '30.01.2010', '250.000000', '100.000000',
'00000086:0000001e');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID,
PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE, "DB_KEY")
VALUES ('8', '888', 'Tata Mcgraw Hill', 'Branch2', '30.01.2010', '600.000000',
'400.000000', '00000086:0000001f');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY") VALUES ('9', '999', 'Tata Mcgraw Hill', 'Branch2', '30.01.2010',
'400.000000', '250.000000', '00000086:00000020');
For every Publisher, for its same Branch and for the same date find the Maximum
Book_No value,if there are multiple records of the same maximum Book_No found
then find the Maximum Book_ID value for that maximum Book_No and get all the
details of that Book_ID row.
SQL:
SELECT BSD.BOOK_NO, BSD.BOOK_ID, BSD.PUBLISHER, BSD.MAIN_BRACH,
BSD.PUBLISH_DATE, BSD.ORIGINAL_PRICE, BSD.SELLING_PRICEFROM BOOK_SELLING_DETAIL
BSDInner Join ( Select BSD1.BOOK_NO, Max(BSD1.BOOK_ID) As BOOK_ID,
BSD1.PUBLISHER, BSD1.MAIN_BRACH, BSD1.PUBLISH_DATE from BOOK_SELLING_DETAIL
BSD1 Inner join ( Select Max(BOOK_NO) As BOOK_NO, PUBLISHER,
MAIN_BRACH, PUBLISH_DATE from BOOK_SELLING_DETAIL Group By PUBLISHER,
MAIN_BRACH, PUBLISH_DATE ) BSD2 ON BSD1.PUBLISHER = BSD2.PUBLISHER
And BSD1.MAIN_BRACH = BSD2.MAIN_BRACH And BSD1.PUBLISH_DATE = BSD2.PUBLISH_DATE
And BSD1.BOOK_NO = BSD2.BOOK_NO Group By BSD1.PUBLISHER,
BSD1.MAIN_BRACH, BSD1.PUBLISH_DATE, BSD1.BOOK_NO ) BSD3ON BSD.BOOK_NO =
BSD3.BOOK_NO And BSD.BOOK_ID = BSD3.BOOK_ID And BSD.PUBLISHER = BSD3.PUBLISHER
And BSD.MAIN_BRACH = BSD3.MAIN_BRACH And BSD.PUBLISH_DATE = BSD3.PUBLISH_DATE
Order By BSD.PUBLISHER, BSD.MAIN_BRACH, BSD.PUBLISH_DATE, BSD.BOOK_NO,
BSD.BOOK_ID
With Best Regards.
Vishal
On Sunday, 29 May 2011 8:49 AM, Vishal Tiwari <[email protected]>
wrote:
| Hi SET, Extreamely sorry for too late reply, coz was busy in project work.
But I am delighted as usual by reading mail.... I have not gone through you
mail, soafter this i would go through yur mail and surly get back to you with
some more doubts on this example. Thanking You And With Best Regards. To My
Master-Trouble Shooter. Vishal
--- On Wed, 18/5/11, Svein Erling Tysvær
<[email protected]> wrote:
From: Svein Erling Tysvær <[email protected]>
Subject: RE: [firebird-support] Doubt (Problem) In Writing SQL
To: "[email protected]" <[email protected]>
Date: Wednesday, 18 May, 2011, 11:08 AM
> Given
>
> Book Book Group Main Sub Publish Original Selling
> NO ID Code Branch Branch Date Price Price
>
> 3 23 'AA02' 'KAR' 'KAR' '2011-03-01' 13.25 13.25
> 5 33 'AWAP' 'KAR' 'KAR' '2011-05-18' 13.45 13.45
> 5 55 'AWAP' 'KAR' 'KAR' '2011-05-18' 12.65 10.65
> 4 57 'AA02' 'KAR' 'KAR' '2011-05-18' 11.12 11.12
> 4 59 'AA02' 'KAR' 'KAR' '2011-05-20' 13.75 13.75
> 5 65 'AWAP' 'KAR' 'KAR' '2011-05-23' 13.25 13.25
> 6 77 '14128' 'KAR' 'KAR' '2011-05-23' 10.65 13.65
> 5 333 'AWAP' 'KEL' 'KEL' '2011-05-18' 13.45 13.45
> 5 355 'AWAP' 'KEL' 'KEL' '2011-05-18' 9.65 5.65
> 4 357 'AA02' 'KEL' 'KEL' '2011-05-18' 11.125 11.12
>
> Here I would like to get the result as, for Each Date, for Each Main Branch
> and for Each Sub Branch,
> look for Maximum value of "Book_NO" column, if there are some, same number of
> values exist for "Book_No"
> column for any respective date, then, look for Maximum value of the "Book_ID"
> column, for the same
> "Book_NO" value, and for Maximum Value of the "Book_ID", take the
> "Original_Price" and "Selling_Price"
> column values.
>
> So the entire sql should give following columns and the values:
>
> Book Book Group Main Sub Publish Original Selling
> NO ID Code Branch Branch Date Price Price
>
> 3 23 'AA02' 'KAR' 'KAR' '2011-03-01' 13.25 13.25
> 5 55 'AWAP' 'KAR' 'KAR' '2011-05-18' 12.65 10.65
> 5 355 'AWAP' 'KEL' 'KEL' '2011-05-18' 9.65 5.65
> 4 59 'AA02' 'KAR' 'KAR' '2011-05-20' 13.75 13.75
> 6 77 '14128' 'KAR' 'KAR' '2011-05-23' 10.65 13.65
Think of your question the opposite way, Vishal, and just eliminate rows that
doesn't fit your requirement. Then, your question can be solved by using NOT
EXISTS or the equivalent LEFT JOIN ... WHERE ... IS NULL, i.e. (if any row
matches the BD2 requirements, then the BD1 row shouldn't be returned)
SELECT BD1.*
FROM BOOK_DETAILS BD1
LEFT JOIN BOOK_DETAILS BD2
ON BD1.PUBLISH_DATE = BD2.PUBLISH_DATE
AND BD1.MAIN_BRANCH = BD2. MAIN_BRANCH
AND BD1.SUB_BRANCH = BD2.SUB_BRANCH
AND (BD1.BOOK_NO < BD2.BOOK_NO
OR (BD1.BOOK_NO = BD2.BOOK_NO
AND BD1.BOOK_ID < BD2.BOOK_ID))
WHERE BD2.BOOK_ID IS NULL
HTH,
Set
<!--#yiv3939070720 #yiv3939070720ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3939070720
#yiv3939070720ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3939070720
#yiv3939070720ygrp-mkp #yiv3939070720hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3939070720 #yiv3939070720ygrp-mkp #yiv3939070720ads
{margin-bottom:10px;}#yiv3939070720 #yiv3939070720ygrp-mkp .yiv3939070720ad
{padding:0 0;}#yiv3939070720 #yiv3939070720ygrp-mkp .yiv3939070720ad p
{margin:0;}#yiv3939070720 #yiv3939070720ygrp-mkp .yiv3939070720ad a
{color:#0000ff;text-decoration:none;}#yiv3939070720 #yiv3939070720ygrp-sponsor
#yiv3939070720ygrp-lc {font-family:Arial;}#yiv3939070720
#yiv3939070720ygrp-sponsor #yiv3939070720ygrp-lc #yiv3939070720hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3939070720
#yiv3939070720ygrp-sponsor #yiv3939070720ygrp-lc .yiv3939070720ad
{margin-bottom:10px;padding:0 0;}#yiv3939070720 a
{color:#1e66ae;}#yiv3939070720 #yiv3939070720actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3939070720
#yiv3939070720activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3939070720
#yiv3939070720activity span {font-weight:700;}#yiv3939070720
#yiv3939070720activity span:first-child
{text-transform:uppercase;}#yiv3939070720 #yiv3939070720activity span a
{color:#5085b6;text-decoration:none;}#yiv3939070720 #yiv3939070720activity span
span {color:#ff7900;}#yiv3939070720 #yiv3939070720activity span
.yiv3939070720underline {text-decoration:underline;}#yiv3939070720
.yiv3939070720attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3939070720 .yiv3939070720attach div a
{text-decoration:none;}#yiv3939070720 .yiv3939070720attach img
{border:none;padding-right:5px;}#yiv3939070720 .yiv3939070720attach label
{display:block;margin-bottom:5px;}#yiv3939070720 .yiv3939070720attach label a
{text-decoration:none;}#yiv3939070720 blockquote {margin:0 0 0
4px;}#yiv3939070720 .yiv3939070720bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3939070720
.yiv3939070720bold a {text-decoration:none;}#yiv3939070720 dd.yiv3939070720last
p a {font-family:Verdana;font-weight:700;}#yiv3939070720 dd.yiv3939070720last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3939070720
dd.yiv3939070720last p span.yiv3939070720yshortcuts
{margin-right:0;}#yiv3939070720 div.yiv3939070720attach-table div div a
{text-decoration:none;}#yiv3939070720 div.yiv3939070720attach-table
{width:400px;}#yiv3939070720 div.yiv3939070720file-title a, #yiv3939070720
div.yiv3939070720file-title a:active, #yiv3939070720
div.yiv3939070720file-title a:hover, #yiv3939070720 div.yiv3939070720file-title
a:visited {text-decoration:none;}#yiv3939070720 div.yiv3939070720photo-title a,
#yiv3939070720 div.yiv3939070720photo-title a:active, #yiv3939070720
div.yiv3939070720photo-title a:hover, #yiv3939070720
div.yiv3939070720photo-title a:visited {text-decoration:none;}#yiv3939070720
div#yiv3939070720ygrp-mlmsg #yiv3939070720ygrp-msg p a
span.yiv3939070720yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3939070720
.yiv3939070720green {color:#628c2a;}#yiv3939070720 .yiv3939070720MsoNormal
{margin:0 0 0 0;}#yiv3939070720 o {font-size:0;}#yiv3939070720
#yiv3939070720photos div {float:left;width:72px;}#yiv3939070720
#yiv3939070720photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv3939070720
#yiv3939070720photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3939070720
#yiv3939070720reco-category {font-size:77%;}#yiv3939070720
#yiv3939070720reco-desc {font-size:77%;}#yiv3939070720 .yiv3939070720replbq
{margin:4px;}#yiv3939070720 #yiv3939070720ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3939070720 #yiv3939070720ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3939070720
#yiv3939070720ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3939070720
#yiv3939070720ygrp-mlmsg select, #yiv3939070720 input, #yiv3939070720 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3939070720
#yiv3939070720ygrp-mlmsg pre, #yiv3939070720 code {font:115%
monospace;}#yiv3939070720 #yiv3939070720ygrp-mlmsg *
{line-height:1.22em;}#yiv3939070720 #yiv3939070720ygrp-mlmsg #yiv3939070720logo
{padding-bottom:10px;}#yiv3939070720 #yiv3939070720ygrp-mlmsg a
{color:#1E66AE;}#yiv3939070720 #yiv3939070720ygrp-msg p a
{font-family:Verdana;}#yiv3939070720 #yiv3939070720ygrp-msg
p#yiv3939070720attach-count span {color:#1E66AE;font-weight:700;}#yiv3939070720
#yiv3939070720ygrp-reco #yiv3939070720reco-head
{color:#ff7900;font-weight:700;}#yiv3939070720 #yiv3939070720ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3939070720 #yiv3939070720ygrp-sponsor
#yiv3939070720ov li a {font-size:130%;text-decoration:none;}#yiv3939070720
#yiv3939070720ygrp-sponsor #yiv3939070720ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3939070720
#yiv3939070720ygrp-sponsor #yiv3939070720ov ul {margin:0;padding:0 0 0
8px;}#yiv3939070720 #yiv3939070720ygrp-text
{font-family:Georgia;}#yiv3939070720 #yiv3939070720ygrp-text p {margin:0 0 1em
0;}#yiv3939070720 #yiv3939070720ygrp-text tt {font-size:120%;}#yiv3939070720
#yiv3939070720ygrp-vital ul li:last-child {border-right:none !important;}-->
|
